data set

Dataset statistics

Number of variables	29
Number of observations	82580
Missing cells	3746
Missing cells (%)	0.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	18.3 MiB
Average record size in memory	232.0 B

Variable types

Numeric	12
Categorical	17

Alerts

`Nationality` has a high cardinality: 188 distinct values	High cardinality
`Unnamed: 0` is highly correlated with `ID` and 3 other fields	High correlation
`ID` is highly correlated with `Unnamed: 0` and 3 other fields	High correlation
`DaysSinceCreation` is highly correlated with `Unnamed: 0` and 3 other fields	High correlation
`AverageLeadTime` is highly correlated with `BookingsCheckedIn` and 3 other fields	High correlation
`BookingsCheckedIn` is highly correlated with `AverageLeadTime` and 5 other fields	High correlation
`PersonsNights` is highly correlated with `AverageLeadTime` and 5 other fields	High correlation
`RoomNights` is highly correlated with `AverageLeadTime` and 5 other fields	High correlation
`DaysSinceLastStay` is highly correlated with `Unnamed: 0` and 6 other fields	High correlation
`DaysSinceFirstStay` is highly correlated with `Unnamed: 0` and 6 other fields	High correlation
`Total Revenue` is highly correlated with `AverageLeadTime` and 3 other fields	High correlation
`Unnamed: 0` is highly correlated with `ID` and 3 other fields	High correlation
`ID` is highly correlated with `Unnamed: 0` and 3 other fields	High correlation
`DaysSinceCreation` is highly correlated with `Unnamed: 0` and 3 other fields	High correlation
`BookingsCheckedIn` is highly correlated with `RoomNights`	High correlation
`PersonsNights` is highly correlated with `RoomNights` and 1 other fields	High correlation
`RoomNights` is highly correlated with `BookingsCheckedIn` and 2 other fields	High correlation
`DaysSinceLastStay` is highly correlated with `Unnamed: 0` and 3 other fields	High correlation
`DaysSinceFirstStay` is highly correlated with `Unnamed: 0` and 3 other fields	High correlation
`Total Revenue` is highly correlated with `PersonsNights` and 1 other fields	High correlation
`Unnamed: 0` is highly correlated with `ID` and 3 other fields	High correlation
`ID` is highly correlated with `Unnamed: 0` and 3 other fields	High correlation
`DaysSinceCreation` is highly correlated with `Unnamed: 0` and 3 other fields	High correlation
`AverageLeadTime` is highly correlated with `BookingsCheckedIn` and 2 other fields	High correlation
`BookingsCheckedIn` is highly correlated with `AverageLeadTime` and 5 other fields	High correlation
`PersonsNights` is highly correlated with `AverageLeadTime` and 3 other fields	High correlation
`RoomNights` is highly correlated with `AverageLeadTime` and 3 other fields	High correlation
`DaysSinceLastStay` is highly correlated with `Unnamed: 0` and 4 other fields	High correlation
`DaysSinceFirstStay` is highly correlated with `Unnamed: 0` and 4 other fields	High correlation
`Total Revenue` is highly correlated with `BookingsCheckedIn` and 2 other fields	High correlation
`MarketSegment` is highly correlated with `DistributionChannel`	High correlation
`DistributionChannel` is highly correlated with `MarketSegment`	High correlation
`Unnamed: 0` is highly correlated with `ID` and 3 other fields	High correlation
`ID` is highly correlated with `Unnamed: 0` and 3 other fields	High correlation
`DaysSinceCreation` is highly correlated with `Unnamed: 0` and 3 other fields	High correlation
`AverageLeadTime` is highly correlated with `DaysSinceLastStay` and 1 other fields	High correlation
`BookingsCanceled` is highly correlated with `BookingsCheckedIn` and 1 other fields	High correlation
`BookingsNoShowed` is highly correlated with `BookingsCheckedIn` and 2 other fields	High correlation
`BookingsCheckedIn` is highly correlated with `BookingsCanceled` and 4 other fields	High correlation
`PersonsNights` is highly correlated with `BookingsNoShowed` and 3 other fields	High correlation
`RoomNights` is highly correlated with `BookingsCanceled` and 4 other fields	High correlation
`DaysSinceLastStay` is highly correlated with `Unnamed: 0` and 4 other fields	High correlation
`DaysSinceFirstStay` is highly correlated with `Unnamed: 0` and 4 other fields	High correlation
`DistributionChannel` is highly correlated with `MarketSegment`	High correlation
`MarketSegment` is highly correlated with `DistributionChannel`	High correlation
`Total Revenue` is highly correlated with `BookingsCheckedIn` and 2 other fields	High correlation
`Age` has 3746 (4.5%) missing values	Missing
`BookingsCanceled` is highly skewed (γ1 = 57.95186518)	Skewed
`BookingsCheckedIn` is highly skewed (γ1 = 27.07036159)	Skewed
`Unnamed: 0` is uniformly distributed	Uniform
`ID` is uniformly distributed	Uniform
`Unnamed: 0` has unique values	Unique
`ID` has unique values	Unique
`AverageLeadTime` has 22157 (26.8%) zeros	Zeros
`BookingsCanceled` has 82462 (99.9%) zeros	Zeros
`BookingsCheckedIn` has 19394 (23.5%) zeros	Zeros
`PersonsNights` has 19396 (23.5%) zeros	Zeros
`RoomNights` has 19394 (23.5%) zeros	Zeros
`Total Revenue` has 19667 (23.8%) zeros	Zeros

Reproduction

Analysis started	2022-09-06 16:39:30.898385
Analysis finished	2022-09-06 16:40:30.168443
Duration	59.27 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

Unnamed: 0
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIFORM
UNIQUE

Distinct	82580
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	41289.5

Minimum	0
Maximum	82579
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	645.3 KiB

Quantile statistics

Minimum	0
5-th percentile	4128.95
Q1	20644.75
median	41289.5
Q3	61934.25
95-th percentile	78450.05
Maximum	82579
Range	82579
Interquartile range (IQR)	41289.5

Descriptive statistics

Standard deviation	23838.93695
Coefficient of variation (CV)	0.5773607564
Kurtosis	-1.2
Mean	41289.5
Median Absolute Deviation (MAD)	20645
Skewness	0
Sum	3409686910
Variance	568294915
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
55080	1	< 0.1%
55058	1	< 0.1%
55057	1	< 0.1%
55056	1	< 0.1%
55055	1	< 0.1%
55054	1	< 0.1%
55053	1	< 0.1%
55052	1	< 0.1%
55051	1	< 0.1%
Other values (82570)	82570	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
82579	1	< 0.1%
82578	1	< 0.1%
82577	1	< 0.1%
82576	1	< 0.1%
82575	1	< 0.1%
82574	1	< 0.1%
82573	1	< 0.1%
82572	1	< 0.1%
82571	1	< 0.1%
82570	1	< 0.1%

ID
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIFORM
UNIQUE

Distinct	82580
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	41290.5

Minimum	1
Maximum	82580
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	645.3 KiB

Quantile statistics

Minimum	1
5-th percentile	4129.95
Q1	20645.75
median	41290.5
Q3	61935.25
95-th percentile	78451.05
Maximum	82580
Range	82579
Interquartile range (IQR)	41289.5

Descriptive statistics

Standard deviation	23838.93695
Coefficient of variation (CV)	0.5773467735
Kurtosis	-1.2
Mean	41290.5
Median Absolute Deviation (MAD)	20645
Skewness	0
Sum	3409769490
Variance	568294915
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	< 0.1%
55081	1	< 0.1%
55059	1	< 0.1%
55058	1	< 0.1%
55057	1	< 0.1%
55056	1	< 0.1%
55055	1	< 0.1%
55054	1	< 0.1%
55053	1	< 0.1%
55052	1	< 0.1%
Other values (82570)	82570	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
82580	1	< 0.1%
82579	1	< 0.1%
82578	1	< 0.1%
82577	1	< 0.1%
82576	1	< 0.1%
82575	1	< 0.1%
82574	1	< 0.1%
82573	1	< 0.1%
82572	1	< 0.1%
82571	1	< 0.1%

Nationality
Categorical

HIGH CARDINALITY

Distinct	188
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	645.3 KiB

FRA	12307
PRT	11382
DEU	10164
GBR	8610
ESP	4864
Other values (183)	35253

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	247740
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	33 ?
Unique (%)	< 0.1%

Sample

1st row	PRT
2nd row	PRT
3rd row	DEU
4th row	FRA
5th row	FRA

Common Values

Value	Count	Frequency (%)
FRA	12307	14.9%
PRT	11382	13.8%
DEU	10164	12.3%
GBR	8610	10.4%
ESP	4864	5.9%
USA	3398	4.1%
ITA	3301	4.0%
BEL	3111	3.8%
BRA	2710	3.3%
NLD	2698	3.3%
Other values (178)	20035	24.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
fra	12307	14.9%
prt	11382	13.8%
deu	10164	12.3%
gbr	8610	10.4%
esp	4864	5.9%
usa	3398	4.1%
ita	3301	4.0%
bel	3111	3.8%
bra	2710	3.3%
nld	2698	3.3%
Other values (178)	20035	24.3%

Most occurring characters

Value	Count	Frequency (%)
R	41541	16.8%
A	26519	10.7%
E	22239	9.0%
U	17848	7.2%
P	17495	7.1%
T	16755	6.8%
B	14932	6.0%
D	13879	5.6%
F	13022	5.3%
S	12285	5.0%
Other values (16)	51225	20.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	247740	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
R	41541	16.8%
A	26519	10.7%
E	22239	9.0%
U	17848	7.2%
P	17495	7.1%
T	16755	6.8%
B	14932	6.0%
D	13879	5.6%
F	13022	5.3%
S	12285	5.0%
Other values (16)	51225	20.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	247740	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
R	41541	16.8%
A	26519	10.7%
E	22239	9.0%
U	17848	7.2%
P	17495	7.1%
T	16755	6.8%
B	14932	6.0%
D	13879	5.6%
F	13022	5.3%
S	12285	5.0%
Other values (16)	51225	20.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	247740	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
R	41541	16.8%
A	26519	10.7%
E	22239	9.0%
U	17848	7.2%
P	17495	7.1%
T	16755	6.8%
B	14932	6.0%
D	13879	5.6%
F	13022	5.3%
S	12285	5.0%
Other values (16)	51225	20.7%

Age
Real number (ℝ)

MISSING

Distinct	105
Distinct (%)	0.1%
Missing	3746
Missing (%)	4.5%
Infinite	0
Infinite (%)	0.0%
Mean	45.46855418

Minimum	-11
Maximum	122
Zeros	40
Zeros (%)	< 0.1%
Negative	17
Negative (%)	< 0.1%
Memory size	645.3 KiB

Quantile statistics

Minimum	-11
5-th percentile	17
Q1	34
median	46
Q3	57
95-th percentile	72
Maximum	122
Range	133
Interquartile range (IQR)	23

Descriptive statistics

Standard deviation	16.52627567
Coefficient of variation (CV)	0.3634660475
Kurtosis	-0.2865254005
Mean	45.46855418
Median Absolute Deviation (MAD)	12
Skewness	-0.156066243
Sum	3584468
Variance	273.1177875
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
50	2015	2.4%
51	2013	2.4%
54	1965	2.4%
53	1913	2.3%
49	1871	2.3%
52	1867	2.3%
48	1858	2.2%
55	1824	2.2%
47	1820	2.2%
46	1717	2.1%
Other values (95)	59971	72.6%
(Missing)	3746	4.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-11	2	< 0.1%
-10	4	< 0.1%
-9	2	< 0.1%
-7	3	< 0.1%
-6	3	< 0.1%
-1	3	< 0.1%
0	40	< 0.1%
1	105	0.1%
2	122	0.1%
3	120	0.1%

Value	Count	Frequency (%)
122	1	< 0.1%
114	2	< 0.1%
113	3	< 0.1%
110	1	< 0.1%
109	1	< 0.1%
96	1	< 0.1%
92	3	< 0.1%
91	1	< 0.1%
90	2	< 0.1%
89	5	< 0.1%

DaysSinceCreation
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1083
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	459.1381569

Minimum	12
Maximum	1095
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	645.3 KiB

Quantile statistics

Minimum	12
5-th percentile	60
Q1	183
median	406
Q3	728
95-th percentile	998
Maximum	1095
Range	1083
Interquartile range (IQR)	545

Descriptive statistics

Standard deviation	311.3092951
Coefficient of variation (CV)	0.6780296745
Kurtosis	-1.152943924
Mean	459.1381569
Median Absolute Deviation (MAD)	249
Skewness	0.3935969279
Sum	37915629
Variance	96913.47721
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
212	298	0.4%
232	247	0.3%
22	233	0.3%
281	227	0.3%
101	225	0.3%
195	220	0.3%
78	211	0.3%
217	211	0.3%
206	207	0.3%
85	206	0.2%
Other values (1073)	80295	97.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12	36	< 0.1%
13	50	0.1%
14	95	0.1%
15	124	0.2%
16	42	0.1%
17	30	< 0.1%
18	39	< 0.1%
19	26	< 0.1%
20	50	0.1%
21	82	0.1%

Value	Count	Frequency (%)
1095	70	0.1%
1094	90	0.1%
1093	103	0.1%
1092	16	< 0.1%
1091	99	0.1%
1090	21	< 0.1%
1089	10	< 0.1%
1088	15	< 0.1%
1087	5	< 0.1%
1086	20	< 0.1%

AverageLeadTime
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	418
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	66.55720513

Minimum	-1
Maximum	588
Zeros	22157
Zeros (%)	26.8%
Negative	10
Negative (%)	< 0.1%
Memory size	645.3 KiB

Quantile statistics

Minimum	-1
5-th percentile	0
Q1	0
median	30
Q3	104
95-th percentile	241
Maximum	588
Range	589
Interquartile range (IQR)	104

Descriptive statistics

Standard deviation	87.92899502
Coefficient of variation (CV)	1.321104076
Kurtosis	4.464738599
Mean	66.55720513
Median Absolute Deviation (MAD)	30
Skewness	1.906882747
Sum	5496294
Variance	7731.508165
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	22157	26.8%
1	1693	2.1%
2	1051	1.3%
6	1040	1.3%
5	1014	1.2%
4	1000	1.2%
3	965	1.2%
7	953	1.2%
8	903	1.1%
9	670	0.8%
Other values (408)	51134	61.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1	10	< 0.1%
0	22157	26.8%
1	1693	2.1%
2	1051	1.3%
3	965	1.2%
4	1000	1.2%
5	1014	1.2%
6	1040	1.3%
7	953	1.2%
8	903	1.1%

Value	Count	Frequency (%)
588	19	< 0.1%
574	10	< 0.1%
549	22	< 0.1%
546	10	< 0.1%
543	2	< 0.1%
542	5	< 0.1%
541	5	< 0.1%
535	21	< 0.1%
533	1	< 0.1%
521	11	< 0.1%

BookingsCanceled
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.002046500363

Minimum	0
Maximum	9
Zeros	82462
Zeros (%)	99.9%
Negative	0
Negative (%)	0.0%
Memory size	645.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	9
Range	9
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.06717662276
Coefficient of variation (CV)	32.82512135
Kurtosis	5207.131053
Mean	0.002046500363
Median Absolute Deviation (MAD)	0
Skewness	57.95186518
Sum	169
Variance	0.004512698645
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	82462	99.9%
1	92	0.1%
2	12	< 0.1%
3	8	< 0.1%
4	5	< 0.1%
9	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	82462	99.9%
1	92	0.1%
2	12	< 0.1%
3	8	< 0.1%
4	5	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
9	1	< 0.1%
4	5	< 0.1%
3	8	< 0.1%
2	12	< 0.1%
1	92	0.1%
0	82462	99.9%

BookingsNoShowed
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	645.3 KiB

0	82536
1	36
2	7
3	1

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	82580
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	82536	99.9%
1	36	< 0.1%
2	7	< 0.1%
3	1	< 0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	82536	99.9%
1	36	< 0.1%
2	7	< 0.1%
3	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	82536	99.9%
1	36	< 0.1%
2	7	< 0.1%
3	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	82580	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	82536	99.9%
1	36	< 0.1%
2	7	< 0.1%
3	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	82580	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	82536	99.9%
1	36	< 0.1%
2	7	< 0.1%
3	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	82580	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	82536	99.9%
1	36	< 0.1%
2	7	< 0.1%
3	1	< 0.1%

BookingsCheckedIn
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	29
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.79840155

Minimum	0
Maximum	66
Zeros	19394
Zeros (%)	23.5%
Negative	0
Negative (%)	0.0%
Memory size	645.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	1
Q3	1
95-th percentile	1
Maximum	66
Range	66
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.6968798281
Coefficient of variation (CV)	0.8728437816
Kurtosis	1847.105958
Mean	0.79840155
Median Absolute Deviation (MAD)	0
Skewness	27.07036159
Sum	65932
Variance	0.4856414949
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
1	61737	74.8%
0	19394	23.5%
2	1141	1.4%
3	132	0.2%
4	59	0.1%
5	20	< 0.1%
6	20	< 0.1%
7	16	< 0.1%
8	10	< 0.1%
9	9	< 0.1%
Other values (19)	42	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	19394	23.5%
1	61737	74.8%
2	1141	1.4%
3	132	0.2%
4	59	0.1%
5	20	< 0.1%
6	20	< 0.1%
7	16	< 0.1%
8	10	< 0.1%
9	9	< 0.1%

Value	Count	Frequency (%)
66	1	< 0.1%
57	1	< 0.1%
40	1	< 0.1%
34	1	< 0.1%
29	3	< 0.1%
26	1	< 0.1%
25	1	< 0.1%
24	1	< 0.1%
23	2	< 0.1%
20	1	< 0.1%

PersonsNights
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	56
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.667958343

Minimum	0
Maximum	116
Zeros	19396
Zeros (%)	23.5%
Negative	0
Negative (%)	0.0%
Memory size	645.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	4
Q3	7
95-th percentile	12
Maximum	116
Range	116
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	4.562507174
Coefficient of variation (CV)	0.9774095737
Kurtosis	12.60176786
Mean	4.667958343
Median Absolute Deviation (MAD)	3
Skewness	1.935882185
Sum	385480
Variance	20.81647172
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	19396	23.5%
6	13639	16.5%
4	10366	12.6%
2	9512	11.5%
8	8199	9.9%
1	4109	5.0%
3	3996	4.8%
10	3434	4.2%
12	3055	3.7%
9	1830	2.2%
Other values (46)	5044	6.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	19396	23.5%
1	4109	5.0%
2	9512	11.5%
3	3996	4.8%
4	10366	12.6%
5	898	1.1%
6	13639	16.5%
7	221	0.3%
8	8199	9.9%
9	1830	2.2%

Value	Count	Frequency (%)
116	1	< 0.1%
78	1	< 0.1%
75	1	< 0.1%
73	1	< 0.1%
68	2	< 0.1%
62	1	< 0.1%
59	1	< 0.1%
56	1	< 0.1%
52	1	< 0.1%
51	1	< 0.1%

RoomNights
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	48
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.36941148

Minimum	0
Maximum	185
Zeros	19394
Zeros (%)	23.5%
Negative	0
Negative (%)	0.0%
Memory size	645.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	2
Q3	4
95-th percentile	6
Maximum	185
Range	185
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.2817575
Coefficient of variation (CV)	0.9630060121
Kurtosis	655.3970849
Mean	2.36941148
Median Absolute Deviation (MAD)	1
Skewness	11.30982346
Sum	195666
Variance	5.20641729
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=48)

Value	Count	Frequency (%)
0	19394	23.5%
3	17084	20.7%
2	14031	17.0%
1	11231	13.6%
4	11083	13.4%
5	4997	6.1%
7	1915	2.3%
6	1830	2.2%
8	368	0.4%
9	195	0.2%
Other values (38)	452	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	19394	23.5%
1	11231	13.6%
2	14031	17.0%
3	17084	20.7%
4	11083	13.4%
5	4997	6.1%
6	1830	2.2%
7	1915	2.3%
8	368	0.4%
9	195	0.2%

Value	Count	Frequency (%)
185	1	< 0.1%
116	1	< 0.1%
95	1	< 0.1%
88	1	< 0.1%
66	1	< 0.1%
59	1	< 0.1%
51	1	< 0.1%
49	1	< 0.1%
42	1	< 0.1%
40	1	< 0.1%

DaysSinceLastStay
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1100
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	405.9354565

Minimum	-1
Maximum	1104
Zeros	0
Zeros (%)	0.0%
Negative	19394
Negative (%)	23.5%
Memory size	645.3 KiB

Quantile statistics

Minimum	-1
5-th percentile	-1
Q1	42
median	378
Q3	698
95-th percentile	982
Maximum	1104
Range	1105
Interquartile range (IQR)	656

Descriptive statistics

Standard deviation	346.5023411
Coefficient of variation (CV)	0.8535897407
Kurtosis	-1.289002372
Mean	405.9354565
Median Absolute Deviation (MAD)	330
Skewness	0.2920894444
Sum	33522150
Variance	120063.8724
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-1	19394	23.5%
920	203	0.2%
472	196	0.2%
477	165	0.2%
938	158	0.2%
97	156	0.2%
192	144	0.2%
217	144	0.2%
442	126	0.2%
206	126	0.2%
Other values (1090)	61768	74.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1	19394	23.5%
2	1	< 0.1%
4	2	< 0.1%
5	4	< 0.1%
8	1	< 0.1%
9	3	< 0.1%
10	1	< 0.1%
11	3	< 0.1%
12	6	< 0.1%
13	16	< 0.1%

Value	Count	Frequency (%)
1104	3	< 0.1%
1102	1	< 0.1%
1101	2	< 0.1%
1100	12	< 0.1%
1099	12	< 0.1%
1098	36	< 0.1%
1097	44	0.1%
1096	37	< 0.1%
1095	14	< 0.1%
1094	55	0.1%

DaysSinceFirstStay
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1096
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	408.2450714

Minimum	-1
Maximum	1186
Zeros	0
Zeros (%)	0.0%
Negative	19394
Negative (%)	23.5%
Memory size	645.3 KiB

Quantile statistics

Minimum	-1
5-th percentile	-1
Q1	44
median	388
Q3	705
95-th percentile	983
Maximum	1186
Range	1187
Interquartile range (IQR)	661

Descriptive statistics

Standard deviation	347.2471272
Coefficient of variation (CV)	0.850584983
Kurtosis	-1.295653749
Mean	408.2450714
Median Absolute Deviation (MAD)	333
Skewness	0.2832263141
Sum	33712878
Variance	120580.5673
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-1	19394	23.5%
920	203	0.2%
472	203	0.2%
477	161	0.2%
938	157	0.2%
97	149	0.2%
217	140	0.2%
192	139	0.2%
442	125	0.2%
206	124	0.2%
Other values (1086)	61785	74.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1	19394	23.5%
13	7	< 0.1%
14	26	< 0.1%
15	15	< 0.1%
16	33	< 0.1%
17	41	< 0.1%
18	36	< 0.1%
19	24	< 0.1%
20	20	< 0.1%
21	42	0.1%

Value	Count	Frequency (%)
1186	1	< 0.1%
1117	1	< 0.1%
1116	1	< 0.1%
1111	1	< 0.1%
1104	3	< 0.1%
1102	1	< 0.1%
1101	2	< 0.1%
1100	12	< 0.1%
1099	12	< 0.1%
1098	36	< 0.1%

DistributionChannel
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	645.3 KiB

Travel Agent/Operator	67798
Direct	11709
Corporate	2565
Electronic Distribution	508

Length

Max length	23
Median length	21
Mean length	18.51272705
Min length	6

Characters and Unicode

Total characters	1528781
Distinct characters	23
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Corporate
2nd row	Travel Agent/Operator
3rd row	Travel Agent/Operator
4th row	Travel Agent/Operator
5th row	Travel Agent/Operator

Common Values

Value	Count	Frequency (%)
Travel Agent/Operator	67798	82.1%
Direct	11709	14.2%
Corporate	2565	3.1%
Electronic Distribution	508	0.6%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
travel	67798	44.9%
agent/operator	67798	44.9%
direct	11709	7.8%
corporate	2565	1.7%
electronic	508	0.3%
distribution	508	0.3%

Most occurring characters

Value	Count	Frequency (%)
r	221249	14.5%
e	218176	14.3%
t	151394	9.9%
a	138161	9.0%
o	73944	4.8%
p	70363	4.6%
n	68814	4.5%
l	68306	4.5%
	68306	4.5%
T	67798	4.4%
Other values (13)	382270	25.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1173993	76.8%
Uppercase Letter	218684	14.3%
Space Separator	68306	4.5%
Other Punctuation	67798	4.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	221249	18.8%
e	218176	18.6%
t	151394	12.9%
a	138161	11.8%
o	73944	6.3%
p	70363	6.0%
n	68814	5.9%
l	68306	5.8%
g	67798	5.8%
v	67798	5.8%
Other values (5)	27990	2.4%

Uppercase Letter

Value	Count	Frequency (%)
T	67798	31.0%
O	67798	31.0%
A	67798	31.0%
D	12217	5.6%
C	2565	1.2%
E	508	0.2%

Space Separator

Value	Count	Frequency (%)
	68306	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	67798	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1392677	91.1%
Common	136104	8.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	221249	15.9%
e	218176	15.7%
t	151394	10.9%
a	138161	9.9%
o	73944	5.3%
p	70363	5.1%
n	68814	4.9%
l	68306	4.9%
T	67798	4.9%
O	67798	4.9%
Other values (11)	246674	17.7%

Common

Value	Count	Frequency (%)
	68306	50.2%
/	67798	49.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1528781	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	221249	14.5%
e	218176	14.3%
t	151394	9.9%
a	138161	9.0%
o	73944	4.8%
p	70363	4.6%
n	68814	4.5%
l	68306	4.5%
	68306	4.5%
T	67798	4.4%
Other values (13)	382270	25.0%

MarketSegment
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	645.3 KiB

Other	47457
Travel Agent/Operator	11482
Direct	11278
Groups	9501
Corporate	2135
Other values (2)	727

Length

Max length	21
Median length	5
Mean length	7.635408089
Min length	5

Characters and Unicode

Total characters	630532
Distinct characters	25
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Corporate
2nd row	Travel Agent/Operator
3rd row	Travel Agent/Operator
4th row	Travel Agent/Operator
5th row	Travel Agent/Operator

Common Values

Value	Count	Frequency (%)
Other	47457	57.5%
Travel Agent/Operator	11482	13.9%
Direct	11278	13.7%
Groups	9501	11.5%
Corporate	2135	2.6%
Complementary	484	0.6%
Aviation	243	0.3%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
other	47457	50.5%
travel	11482	12.2%
agent/operator	11482	12.2%
direct	11278	12.0%
groups	9501	10.1%
corporate	2135	2.3%
complementary	484	0.5%
aviation	243	0.3%

Most occurring characters

Value	Count	Frequency (%)
r	107436	17.0%
e	96284	15.3%
t	84561	13.4%
O	58939	9.3%
h	47457	7.5%
o	25980	4.1%
a	25826	4.1%
p	23602	3.7%
n	12209	1.9%
l	11966	1.9%
Other values (15)	136272	21.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	502024	79.6%
Uppercase Letter	105544	16.7%
Space Separator	11482	1.8%
Other Punctuation	11482	1.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	107436	21.4%
e	96284	19.2%
t	84561	16.8%
h	47457	9.5%
o	25980	5.2%
a	25826	5.1%
p	23602	4.7%
n	12209	2.4%
l	11966	2.4%
i	11764	2.3%
Other values (7)	54939	10.9%

Uppercase Letter

Value	Count	Frequency (%)
O	58939	55.8%
A	11725	11.1%
T	11482	10.9%
D	11278	10.7%
G	9501	9.0%
C	2619	2.5%

Space Separator

Value	Count	Frequency (%)
	11482	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	11482	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	607568	96.4%
Common	22964	3.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	107436	17.7%
e	96284	15.8%
t	84561	13.9%
O	58939	9.7%
h	47457	7.8%
o	25980	4.3%
a	25826	4.3%
p	23602	3.9%
n	12209	2.0%
l	11966	2.0%
Other values (13)	113308	18.6%

Common

Value	Count	Frequency (%)
	11482	50.0%
/	11482	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	630532	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	107436	17.0%
e	96284	15.3%
t	84561	13.4%
O	58939	9.3%
h	47457	7.5%
o	25980	4.1%
a	25826	4.1%
p	23602	3.7%
n	12209	1.9%
l	11966	1.9%
Other values (15)	136272	21.6%

SRHighFloor
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	645.3 KiB

0	78656
1	3924

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	82580
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	78656	95.2%
1	3924	4.8%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	78656	95.2%
1	3924	4.8%

Most occurring characters

Value	Count	Frequency (%)
0	78656	95.2%
1	3924	4.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	82580	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	78656	95.2%
1	3924	4.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	82580	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	78656	95.2%
1	3924	4.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	82580	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	78656	95.2%
1	3924	4.8%

SRLowFloor
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	645.3 KiB

0	82462
1	118

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	82580
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	82462	99.9%
1	118	0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	82462	99.9%
1	118	0.1%

Most occurring characters

Value	Count	Frequency (%)
0	82462	99.9%
1	118	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	82580	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	82462	99.9%
1	118	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	82580	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	82462	99.9%
1	118	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	82580	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	82462	99.9%
1	118	0.1%

SRAccessibleRoom
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	645.3 KiB

0	82559
1	21

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	82580
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	82559	> 99.9%
1	21	< 0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	82559	> 99.9%
1	21	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	82559	> 99.9%
1	21	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	82580	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	82559	> 99.9%
1	21	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	82580	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	82559	> 99.9%
1	21	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	82580	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	82559	> 99.9%
1	21	< 0.1%

SRMediumFloor
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	645.3 KiB

0	82507
1	73

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	82580
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	82507	99.9%
1	73	0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	82507	99.9%
1	73	0.1%

Most occurring characters

Value	Count	Frequency (%)
0	82507	99.9%
1	73	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	82580	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	82507	99.9%
1	73	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	82580	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	82507	99.9%
1	73	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	82580	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	82507	99.9%
1	73	0.1%

SRBathtub
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	645.3 KiB

0	82348
1	232

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	82580
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	82348	99.7%
1	232	0.3%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	82348	99.7%
1	232	0.3%

Most occurring characters

Value	Count	Frequency (%)
0	82348	99.7%
1	232	0.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	82580	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	82348	99.7%
1	232	0.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	82580	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	82348	99.7%
1	232	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	82580	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	82348	99.7%
1	232	0.3%

SRShower
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	645.3 KiB

0	82437
1	143

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	82580
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	82437	99.8%
1	143	0.2%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	82437	99.8%
1	143	0.2%

Most occurring characters

Value	Count	Frequency (%)
0	82437	99.8%
1	143	0.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	82580	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	82437	99.8%
1	143	0.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	82580	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	82437	99.8%
1	143	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	82580	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	82437	99.8%
1	143	0.2%

SRCrib
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	645.3 KiB

0	81522
1	1058

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	82580
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	81522	98.7%
1	1058	1.3%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	81522	98.7%
1	1058	1.3%

Most occurring characters

Value	Count	Frequency (%)
0	81522	98.7%
1	1058	1.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	82580	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	81522	98.7%
1	1058	1.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	82580	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	81522	98.7%
1	1058	1.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	82580	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	81522	98.7%
1	1058	1.3%

SRKingSizeBed
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	645.3 KiB

0	53539
1	29041

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	82580
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	53539	64.8%
1	29041	35.2%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	53539	64.8%
1	29041	35.2%

Most occurring characters

Value	Count	Frequency (%)
0	53539	64.8%
1	29041	35.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	82580	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	53539	64.8%
1	29041	35.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	82580	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	53539	64.8%
1	29041	35.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	82580	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	53539	64.8%
1	29041	35.2%

SRTwinBed
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	645.3 KiB

0	70790
1	11790

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	82580
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	70790	85.7%
1	11790	14.3%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	70790	85.7%
1	11790	14.3%

Most occurring characters

Value	Count	Frequency (%)
0	70790	85.7%
1	11790	14.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	82580	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	70790	85.7%
1	11790	14.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	82580	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	70790	85.7%
1	11790	14.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	82580	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	70790	85.7%
1	11790	14.3%

SRNearElevator
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	645.3 KiB

0	82555
1	25

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	82580
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	82555	> 99.9%
1	25	< 0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	82555	> 99.9%
1	25	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	82555	> 99.9%
1	25	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	82580	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	82555	> 99.9%
1	25	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	82580	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	82555	> 99.9%
1	25	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	82580	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	82555	> 99.9%
1	25	< 0.1%

SRAwayFromElevator
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	645.3 KiB

0	82287
1	293

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	82580
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	82287	99.6%
1	293	0.4%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	82287	99.6%
1	293	0.4%

Most occurring characters

Value	Count	Frequency (%)
0	82287	99.6%
1	293	0.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	82580	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	82287	99.6%
1	293	0.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	82580	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	82287	99.6%
1	293	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	82580	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	82287	99.6%
1	293	0.4%

SRNoAlcoholInMiniBar
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	645.3 KiB

0	82570
1	10

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	82580
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	82570	> 99.9%
1	10	< 0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	82570	> 99.9%
1	10	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	82570	> 99.9%
1	10	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	82580	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	82570	> 99.9%
1	10	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	82580	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	82570	> 99.9%
1	10	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	82580	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	82570	> 99.9%
1	10	< 0.1%

SRQuietRoom
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	645.3 KiB

0	75308
1	7272

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	82580
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	75308	91.2%
1	7272	8.8%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	75308	91.2%
1	7272	8.8%

Most occurring characters

Value	Count	Frequency (%)
0	75308	91.2%
1	7272	8.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	82580	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	75308	91.2%
1	7272	8.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	82580	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	75308	91.2%
1	7272	8.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	82580	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	75308	91.2%
1	7272	8.8%

Total Revenue
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	16637
Distinct (%)	20.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	368.3473957

Minimum	0
Maximum	23365
Zeros	19667
Zeros (%)	23.8%
Negative	0
Negative (%)	0.0%
Memory size	645.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	80
median	289
Q3	498.75
95-th percentile	1084.5
Maximum	23365
Range	23365
Interquartile range (IQR)	418.75

Descriptive statistics

Standard deviation	444.2943523
Coefficient of variation (CV)	1.206182961
Kurtosis	131.0727867
Mean	368.3473957
Median Absolute Deviation (MAD)	209.5
Skewness	5.789490849
Sum	30418127.94
Variance	197397.4715
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	19667	23.8%
234	295	0.4%
248.8	205	0.2%
302	199	0.2%
182	189	0.2%
359	187	0.2%
81	184	0.2%
162	172	0.2%
344	171	0.2%
242	171	0.2%
Other values (16627)	61140	74.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	19667	23.8%
1	3	< 0.1%
2	15	< 0.1%
2.5	3	< 0.1%
3	10	< 0.1%
3.5	1	< 0.1%
4	17	< 0.1%
4.5	1	< 0.1%
5	6	< 0.1%
5.5	3	< 0.1%

Value	Count	Frequency (%)
23365	1	< 0.1%
11930.66	1	< 0.1%
11081.15	1	< 0.1%
10982.4	1	< 0.1%
10324.5	1	< 0.1%
9576.8	1	< 0.1%
9188.75	1	< 0.1%
8607	1	< 0.1%
8110.98	1	< 0.1%
8003	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	Unnamed: 0	ID	Nationality	Age	DaysSinceCreation	AverageLeadTime	BookingsCanceled	BookingsCheckedIn	PersonsNights	RoomNights	DaysSinceLastStay	DaysSinceFirstStay	DistributionChannel	MarketSegment	SRKingSizeBed	Total Revenue
0	0	1	PRT	51.0	150	45	1	3	8	5	151	1074	Corporate	Corporate	0	476.3
1	1	2	PRT	NaN	1095	61	0	1	10	5	1100	1100	Travel Agent/Operator	Travel Agent/Operator	0	333.0
2	2	3	DEU	31.0	1095	0	0	0	0	0	-1	-1	Travel Agent/Operator	Travel Agent/Operator	0	0.0
3	3	4	FRA	60.0	1095	93	0	1	10	5	1100	1100	Travel Agent/Operator	Travel Agent/Operator	0	300.0
4	4	5	FRA	51.0	1095	0	0	0	0	0	-1	-1	Travel Agent/Operator	Travel Agent/Operator	0	0.0
5	5	6	JPN	54.0	1095	58	0	1	4	2	1097	1097	Travel Agent/Operator	Other	0	254.0
6	6	7	JPN	49.0	1095	0	0	0	0	0	-1	-1	Travel Agent/Operator	Other	0	0.0
7	7	8	FRA	32.0	1095	38	0	1	10	5	1100	1100	Travel Agent/Operator	Other	1	629.0
8	8	9	FRA	42.0	1095	0	0	0	0	0	-1	-1	Travel Agent/Operator	Other	1	0.0
9	9	10	IRL	25.0	1095	96	0	1	6	3	1098	1098	Travel Agent/Operator	Travel Agent/Operator	0	243.0

Last rows

	Unnamed: 0	ID	Nationality	Age	DaysSinceCreation	AverageLeadTime	BookingsCheckedIn	PersonsNights	RoomNights	DaysSinceLastStay	DaysSinceFirstStay	DistributionChannel	MarketSegment	SRKingSizeBed	Total Revenue
82570	82570	82571	ROU	37.0	12	64	1	8	4	16	16	Travel Agent/Operator	Other	0	409.20
82571	82571	82572	ROU	36.0	12	0	0	0	0	-1	-1	Travel Agent/Operator	Other	0	0.00
82572	82572	82573	FRA	32.0	12	88	1	4	2	14	14	Travel Agent/Operator	Travel Agent/Operator	0	154.00
82573	82573	82574	FRA	34.0	12	0	0	0	0	-1	-1	Travel Agent/Operator	Travel Agent/Operator	0	0.00
82574	82574	82575	PRT	41.0	12	7	1	1	1	13	13	Travel Agent/Operator	Other	0	82.18
82575	82575	82576	SWE	51.0	12	114	1	6	3	15	15	Travel Agent/Operator	Other	1	196.08
82576	82576	82577	SWE	50.0	12	0	0	0	0	-1	-1	Travel Agent/Operator	Other	1	0.00
82577	82577	82578	DEU	50.0	12	18	1	3	3	15	15	Travel Agent/Operator	Other	0	477.00
82578	82578	82579	PRT	NaN	12	11	1	3	3	15	15	Travel Agent/Operator	Other	0	264.00
82579	82579	82580	DEU	17.0	12	0	0	0	0	-1	-1	Travel Agent/Operator	Other	0	0.00

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category